Alias
An alternate name for a column (property).
For example, you could define Postal Code as the alias for the Zip column name.
Business Object
A collection of self-contained data that represents an entity or process, and shields the physical data.
For example, the CsContact business object can represent a view of a person or organization and the processes that a person or organization can perform.
Comparison Method
Specifies the method by which data is restricted for a column.
For example, to return orders for more than $1000.00, create a filter set that uses the "Greater" Comparison operator and enter "1000" in the Value field.
CORE
Central Object Repository. A server-side file system containing documents and objects (business objects, query objects, and output processes).
Example of CORE with content folders
Display Order
Refers to the columns that display in the results for a query.
Note: The default column sort order is derived from the first query source. You can override the sort order, if necessary.
Example of a query definition showing display order
Filter
One or more column-specific search conditions.
For example, if you wanted all contacts who live in Texas (CsContact.STATE_PROVINCE = "TX") or who subscribe to a journal (Subscriptions.PRODUCT_CODE = "JOUR"), you could define a filter set using the Or connector, so that only those contacts either from Texas or who subscribe to a journal return.
Example of a filter set
Function
Summarizes some characteristic of the current set of rows. The functions that are available depends on the data type of the column you selected.
Note: You must select only one column when using a function. For example, if you want the maximum ID, ID must be the only column listed on the Display tab.
Avg |
Returns the average of the values in the specified column. |
Count |
Returns the number of rows that are in the table or that meet certain conditions. |
Max |
Returns the maximum value found in the specified column. |
Min |
Returns the minimum value found in the specified column. |
Sum |
Returns the sum of all values found in the specified column. |
IQA
Intelligent Query Architect. The query-building tool used to extract data from the iMIS database.
Join Operator
The logic that combines data from multiple tables into a single result table. The following join operators are available in IQA:
Object
Self-contained element that consists of instructions to manipulate data; for example, a business object or query object.
Parameterized Query
A query that requires a value from the user at runtime.
For example, a query to obtain the registrants for a closed event may prompt the user at runtime to supply the event code of the closed event.
Example of a filter definition for a parameterized query
Example of a prompt that displays when a parameterized query is run
Priority
Refers to the order in which the data for a particular column is sorted.
Example of a query definition showing a specified sort order
Query
User-defined criteria used to retrieve a subset of data.
Relation
The part of a query definition that specifies a relationship between two or more sources and is used to restrict the data the query returns.
For example, if you wanted to define a query that returns members with orders over the amount of $1,000, you could create a relationship where the CsContact.Id = CsOrders.BillToId.
Note: You can use the default relation, if one exists, or you can define a specific relation.
Example of a query definition showing a default relation
Schema
Refers to the structure of a database.
Source
Object that is available for building query definitions. Sources include both business objects and query objects. Query definitions can be created based on one or more sources.
10.6 Production Release. Updated 7/27/2006 3:52:52 PM
© 2009 by Advanced Solutions International, Inc.
All rights reserved.